﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Skyworth.CRM.Service.Entity;

namespace Skyworth.CRM.Service.IDAL
{
    public interface IProductDAL
    {
        DataTable GetProductsByPage(string strWhere, string strOrderBy, int pageIndex, int pageSize,
                                           out int recordCount, out int pageCount);
        void Delete(int productId);
        Product GetProductById(int productId);

        void Add(Product product);

        void Update(Product product);

        DataTable Query(string strWhere);

        DataTable GetPriceInfo(int custId,DateTime date,string strWhere );

        DataTable GetProductsWithPriceByPage(string strWhere, string custId, string strOrderBy, int pageIndex,
                                                   int pageSize, out int recordCount, out int pageCount);

        void Disable(int productId);
        void Enable(int productId);
    }
}
